package com.mybatis.mapper;

import com.mybatis.entity.Student;
import com.mybatis.entity.StudentVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentMapper {


    List<Student> getList();

    List<StudentVO> getPage(@Param("page") int page);

    List<StudentVO> getSearchPage(StudentVO studentVO);

    @Select("select count(*) from student")
    Integer getSize();

    Integer getSearchSize(StudentVO studentVO);

    void delete(@Param("sno") String sno);

    void insert(Student student);

    Student getOne(Student student);

    Student getBySno(@Param("sno") String sno);

    void update(Student student);

    //Student getBySnoToVO(@Param("sno") String sno);

    List<String> getByClass();

    List<String> getByMajor();

    List<String> getByDepartment();

}
